Evaluation of the Microsoft Excel Solver Spreadsheet-Based Program for Nonlinear Expressions of Adsorption Isotherm Models onto Magnetic Nanosorbent

The sorption of basic dyes onto magnetic nanosorbent is commonly used as a novel material to combat powdered activated carbon, which difficult handle and separate during water wastewater treatment. This adsorption method implemented in treatment due its low cost high performance. To explore the feasibility adsorption, six different nonlinear isotherm models were applied introduced evaluate performance mechanisms via Microsoft Excel, they then compared those MATLAB OriginPro. Langmuir best provided methylene blue adsorbed for two-parameter model. three-parameter model Toth gave goodness fit indicating heterogeneous sorbent surface. Error function analysis found that Residual Sum Squares Error, Chi-square, Coefficient determination, Average Relative Hybrid Fractional Function, Marquardt’s Percent Standard Deviation Root Mean Square overall results. In comparison, it could be concluded showed confidence interval simply at all experimental data points by three software tools. All error results indicated Excel Solver spreadsheet satisfied statistic measures predict real variance probability dye removal. One added benefit this tool built-in associated with desired type application, designates error/statistical functions not mentioned research adsorbent materials used.